Personal Computer World 2005 October/PCWOCT05.iso/Software/FromTheMag/XAMPP 1.4.14/xampp-win32-1.4.14-installer.exe/xampp/php/pear/adodb/session/adodb-sessions.oracle.sql

Text File | 2003-11-04 | 313b | 17 lines

-- $CVSHeader$

DROP TABLE adodb_sessions;

CREATE TABLE sessions (
    sesskey        CHAR(32)    DEFAULT '' NOT NULL,
    expiry        INT        DEFAULT 0 NOT NULL,
    expireref    VARCHAR(64)    DEFAULT '',
    data        VARCHAR(4000)    DEFAULT '',
    PRIMARY KEY    (sesskey),
    INDEX expiry (expiry)
);

CREATE INDEX ix_expiry ON sessions (expiry);

QUIT;